Carson Penticuff
Carson Penticuff
Reactions
-
Re: Count IF Question
You will have to adjust this to match what you are using for cross sheet reference names. I tend to stick with COUNTIFS even for a single condition over COUNTIF just because I prefer the consistency …1 · -
Re: extra characters returned when no needed
Try this one instead. I wasn't sure if you would ever have only the first name or last fields populated, so this accounts for that possibility as well. If they are both blank, the cell will be blank.…1 · -
Re: Using COUNTIFS to count number of occurrences within two different sheets = UNPARSEABLE
I understand what you are attempting to do, but I am not 100% confident that I interpreted which references belong to which sheet in the formula. Try this and see if it works: =COUNTIFS({Polaris minu…1 · -
Re: COUNTA alternative in Smartsheet
You are dead on with the concept... you only missed it with parentheses. =IF(SUM([AR]@row:[AT]@row) > 0, IF(OR(ISBLANK([AU]@row), ISBLANK([AV]@row)), "Please enter review reason and detailed …1 · -
Re: COUNTA alternative in Smartsheet
You are correct in that COUNTA is not present in Smartsheet. You can use COUNTIF, as you mentioned, though I prefer to use COUNTIFS instead. There is also no IFS, so to cover multiple cases, we must …1 ·
